mysql> create database tarea;
Query OK, 1 row affected (0.13 sec)

mysql> use tarea;
Database changed
mysql> create table clientes(
    -> idcliente int primary key,
    -> nombre varchar(45),
    -> descripcion varchar(45));
Query OK, 0 rows affected (0.66 sec)

mysql> create table cuentas(
    -> idcuenta int primary key,
    -> saldo float,
    -> idcliente int,
    -> foreign key(idcliente) references clientes(idcliente) on update cascade on delete cascade);
Query OK, 0 rows affected (0.31 sec)

mysql> create table prestamos(
    -> idprestamo int primary key,
    -> descripcion varchar(45),
    -> plazo int,
    -> fecha_inicio date,
    -> idcliente int,
    -> foreign key(idcliente) references clientes(idcliente) on update cascade on delete cascade);
Query OK, 0 rows affected (0.44 sec)